Live freelance tracking. Raw descriptions turned into structured data. Find your next tech project without the noise.
freelancer.com ๐ 2026-05-12
๐น Automate Google Search for Company Websites and Extract Contact Information
๐ค Client: ๐ฎ๐ณ Ahmedabad, India Member since 2026-04-30
๐ฐ Price: $94 Average bid
๐ฉ Problem: Need a robust Python script to automate Google searches for company websites and extract contact information using ScrapeGraphAI.
๐ฆ Existing: Not specified
Specifications:
[Target] - Automate search, website extraction, and data scraping for 20,000 companies.
[Method] - Use Selenium or Playwright for browser automation; integrate with ScrapeGraphAI API for data extraction.
[UI/UX] - Not applicable
[Stack] - Python, Selenium/Playwright, ScrapeGraphAI API, XLSX library (openpyxl)
[Security] - Secure handling of API keys and proxy rotation. Implement rate limiting to avoid CAPTCHA triggers.
[Format] - Final output in Excel or CSV with columns: company, website, email, phone
Workflow:
1. Read company names from an Excel sheet using openpyxl.
2. For each company name, perform a Google search and locate the official website or contact page.
3. Use Selenium/Playwright to navigate through the results and click on the relevant link.
4. Extract the URL of the selected website.
5. Push the URL to ScrapeGraphAIโs Extract endpoint using provided API key, prompt, and JSON schema.
6. Parse the response from ScrapeGraphAI for emails and phone numbers.
7. Write the extracted data (company name, website, email, phone) back to a new Excel file.